Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 560129 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 14188 |
| Duplicate rows (%) | 2.5% |
| Total size in memory | 65.2 MiB |
| Average record size in memory | 122.0 B |
Variable types
| DateTime | 2 |
|---|---|
| Numeric | 9 |
| Categorical | 4 |
| Text | 1 |
| Dataset has 14188 (2.5%) duplicate rows | Duplicates |
subcategory has a high cardinality: 53 distinct values | High cardinality |
category is highly overall correlated with subcategory | High correlation |
deplaned_passenger is highly overall correlated with enplaned_passenger | High correlation |
enplaned_passenger is highly overall correlated with deplaned_passenger | High correlation |
incident_no is highly overall correlated with incident_year | High correlation |
incident_year is highly overall correlated with incident_no | High correlation |
latitude is highly overall correlated with neighborhood | High correlation |
longitude is highly overall correlated with neighborhood | High correlation |
max_temperature is highly overall correlated with min_temperature | High correlation |
min_temperature is highly overall correlated with max_temperature | High correlation |
neighborhood is highly overall correlated with latitude and 1 other fields | High correlation |
subcategory is highly overall correlated with category | High correlation |
precipitation has 461640 (82.4%) zeros | Zeros |
Reproduction
| Analysis started | 2024-07-17 14:36:00.165998 |
|---|---|
| Analysis finished | 2024-07-17 14:37:08.984351 |
| Duration | 1 minute and 8.82 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
incident_date
Date
| Distinct | 2382 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 MiB |
| Minimum | 2018-01-01 00:00:00 |
|---|---|
| Maximum | 2024-07-09 00:00:00 |
Histogram with fixed size bins (bins=50)
incident_time
Date
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 MiB |
| Minimum | 2024-07-17 00:00:00 |
|---|---|
| Maximum | 2024-07-17 23:59:00 |
Histogram with fixed size bins (bins=50)
incident_year
Real number (ℝ)
HIGH CORRELATION
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2020.6606 |
| Minimum | 2018 |
|---|---|
| Maximum | 2024 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 2018 |
|---|---|
| 5-th percentile | 2018 |
| Q1 | 2019 |
| median | 2021 |
| Q3 | 2022 |
| 95-th percentile | 2024 |
| Maximum | 2024 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.8921166 |
|---|---|
| Coefficient of variation (CV) | 0.00093638518 |
| Kurtosis | -1.23106 |
| Mean | 2020.6606 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.079722469 |
| Sum | 1.1318306 × 109 |
| Variance | 3.5801054 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 2018 | 97239 | |
| 2019 | 94823 | |
| 2022 | 90138 | |
| 2023 | 86866 | |
| 2021 | 83388 | |
| 2020 | 73910 | |
| 2024 | 33765 | 6.0% |
| Value | Count | Frequency (%) |
| 2018 | 97239 | |
| 2019 | 94823 | |
| 2020 | 73910 | |
| 2021 | 83388 | |
| 2022 | 90138 | |
| 2023 | 86866 | |
| 2024 | 33765 | 6.0% |
| Value | Count | Frequency (%) |
| 2024 | 33765 | 6.0% |
| 2023 | 86866 | |
| 2022 | 90138 | |
| 2021 | 83388 | |
| 2020 | 73910 | |
| 2019 | 94823 | |
| 2018 | 97239 |
incident_day
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 MiB |
| Friday | |
|---|---|
| Saturday | |
| Wednesday | |
| Thursday | |
| Monday | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 7.1448059 |
| Min length | 6 |
Characters and Unicode
| Total characters | 4002013 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Monday |
|---|---|
| 2nd row | Monday |
| 3rd row | Monday |
| 4th row | Monday |
| 5th row | Monday |
Common Values
| Value | Count | Frequency (%) |
| Friday | 87435 | |
| Saturday | 81594 | |
| Wednesday | 81358 | |
| Thursday | 78490 | |
| Monday | 78473 | |
| Tuesday | 76997 | |
| Sunday | 75782 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| friday | 87435 | |
| saturday | 81594 | |
| wednesday | 81358 | |
| thursday | 78490 | |
| monday | 78473 | |
| tuesday | 76997 | |
| sunday | 75782 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 641723 | |
| d | 641487 | |
| y | 560129 | |
| u | 312863 | |
| r | 247519 | 6.2% |
| e | 239713 | 6.0% |
| s | 236845 | 5.9% |
| n | 235613 | 5.9% |
| S | 157376 | 3.9% |
| T | 155487 | 3.9% |
| Other values (7) | 573258 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4002013 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 641723 | |
| d | 641487 | |
| y | 560129 | |
| u | 312863 | |
| r | 247519 | 6.2% |
| e | 239713 | 6.0% |
| s | 236845 | 5.9% |
| n | 235613 | 5.9% |
| S | 157376 | 3.9% |
| T | 155487 | 3.9% |
| Other values (7) | 573258 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4002013 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 641723 | |
| d | 641487 | |
| y | 560129 | |
| u | 312863 | |
| r | 247519 | 6.2% |
| e | 239713 | 6.0% |
| s | 236845 | 5.9% |
| n | 235613 | 5.9% |
| S | 157376 | 3.9% |
| T | 155487 | 3.9% |
| Other values (7) | 573258 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4002013 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 641723 | |
| d | 641487 | |
| y | 560129 | |
| u | 312863 | |
| r | 247519 | 6.2% |
| e | 239713 | 6.0% |
| s | 236845 | 5.9% |
| n | 235613 | 5.9% |
| S | 157376 | 3.9% |
| T | 155487 | 3.9% |
| Other values (7) | 573258 |
incident_no
Real number (ℝ)
HIGH CORRELATION
| Distinct | 510613 |
|---|---|
| Distinct (%) | 91.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0888726 × 108 |
| Minimum | 0 |
|---|---|
| Maximum | 9.81172 × 108 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.8044113 × 108 |
| Q1 | 1.90685 × 108 |
| median | 2.1022944 × 108 |
| Q3 | 2.2609293 × 108 |
| 95-th percentile | 2.4010689 × 108 |
| Maximum | 9.81172 × 108 |
| Range | 9.81172 × 108 |
| Interquartile range (IQR) | 35407928 |
Descriptive statistics
| Standard deviation | 19227070 |
|---|---|
| Coefficient of variation (CV) | 0.092045199 |
| Kurtosis | 17.225027 |
| Mean | 2.0888726 × 108 |
| Median Absolute Deviation (MAD) | 19282543 |
| Skewness | 0.45126775 |
| Sum | 1.1700381 × 1014 |
| Variance | 3.696802 × 1014 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 190202001 | 229 | < 0.1% |
| 106000012 | 15 | < 0.1% |
| 210504882 | 14 | < 0.1% |
| 210862561 | 14 | < 0.1% |
| 200464246 | 13 | < 0.1% |
| 210737328 | 13 | < 0.1% |
| 206093035 | 11 | < 0.1% |
| 100000000 | 11 | < 0.1% |
| 180084104 | 10 | < 0.1% |
| 200734544 | 10 | < 0.1% |
| Other values (510603) | 559789 |
| Value | Count | Frequency (%) |
| 0 | 2 | |
| 1808670 | 1 | |
| 1813494 | 1 | |
| 1819855 | 1 | |
| 1819873 | 1 | |
| 1831758 | 1 | |
| 1831875 | 1 | |
| 2000558 | 1 | |
| 2001461 | 1 | |
| 2002056 | 1 |
| Value | Count | Frequency (%) |
| 981171996 | 1 | |
| 981081925 | 1 | |
| 911272570 | 1 | |
| 793282725 | 1 | |
| 782312915 | 1 | |
| 773809399 | 1 | |
| 700013570 | 1 | |
| 270762961 | 1 | |
| 251030935 | 1 | |
| 250328844 | 1 |
category
Categorical
HIGH CORRELATION
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.8 MiB |
| Larceny Theft | |
|---|---|
| Vandalism | |
| Assault | |
| Motor Vehicle Theft | |
| Burglary | |
| Other values (24) |
Length
| Max length | 44 |
|---|---|
| Median length | 13 |
| Mean length | 12.263047 |
| Min length | 4 |
Characters and Unicode
| Total characters | 6868888 |
|---|---|
| Distinct characters | 45 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Assault |
|---|---|
| 2nd row | Miscellaneous Investigation |
| 3rd row | Miscellaneous Investigation |
| 4th row | Fraud |
| 5th row | Miscellaneous Investigation |
Common Values
| Value | Count | Frequency (%) |
| Larceny Theft | 258689 | |
| Vandalism | 53633 | 9.6% |
| Assault | 46011 | 8.2% |
| Motor Vehicle Theft | 45837 | 8.2% |
| Burglary | 42970 | 7.7% |
| Lost Property | 24509 | 4.4% |
| Fraud | 21519 | 3.8% |
| Robbery | 14588 | 2.6% |
| Drug Offense | 12500 | 2.2% |
| Disorderly Conduct | 9408 | 1.7% |
| Other values (19) | 30465 | 5.4% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| theft | 304565 | |
| larceny | 258689 | |
| vandalism | 53633 | 5.4% |
| vehicle | 46642 | 4.7% |
| assault | 46011 | 4.6% |
| motor | 45876 | 4.6% |
| burglary | 42970 | 4.3% |
| property | 25959 | 2.6% |
| lost | 24509 | 2.5% |
| fraud | 21519 | 2.2% |
| Other values (34) | 124608 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 790905 | 11.5% |
| r | 544340 | 7.9% |
| a | 517698 | 7.5% |
| t | 499842 | 7.3% |
| 434852 | 6.3% | |
| n | 391183 | 5.7% |
| y | 355165 | 5.2% |
| f | 354315 | 5.2% |
| h | 351207 | 5.1% |
| c | 337234 | 4.9% |
| Other values (35) | 2292147 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6868888 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 790905 | 11.5% |
| r | 544340 | 7.9% |
| a | 517698 | 7.5% |
| t | 499842 | 7.3% |
| 434852 | 6.3% | |
| n | 391183 | 5.7% |
| y | 355165 | 5.2% |
| f | 354315 | 5.2% |
| h | 351207 | 5.1% |
| c | 337234 | 4.9% |
| Other values (35) | 2292147 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6868888 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 790905 | 11.5% |
| r | 544340 | 7.9% |
| a | 517698 | 7.5% |
| t | 499842 | 7.3% |
| 434852 | 6.3% | |
| n | 391183 | 5.7% |
| y | 355165 | 5.2% |
| f | 354315 | 5.2% |
| h | 351207 | 5.1% |
| c | 337234 | 4.9% |
| Other values (35) | 2292147 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6868888 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 790905 | 11.5% |
| r | 544340 | 7.9% |
| a | 517698 | 7.5% |
| t | 499842 | 7.3% |
| 434852 | 6.3% | |
| n | 391183 | 5.7% |
| y | 355165 | 5.2% |
| f | 354315 | 5.2% |
| h | 351207 | 5.1% |
| c | 337234 | 4.9% |
| Other values (35) | 2292147 |
subcategory
Categorical
HIGH CARDINALITY HIGH CORRELATION
| Distinct | 53 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.8 MiB |
| Larceny - From Vehicle | |
|---|---|
| Larceny Theft - Other | |
| Vandalism | |
| Motor Vehicle Theft | |
| Simple Assault | |
| Other values (48) |
Length
| Max length | 40 |
|---|---|
| Median length | 29 |
| Mean length | 18.313098 |
| Min length | 4 |
Characters and Unicode
| Total characters | 10257697 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Simple Assault |
|---|---|
| 2nd row | Miscellaneous Investigation |
| 3rd row | Miscellaneous Investigation |
| 4th row | Fraud |
| 5th row | Miscellaneous Investigation |
Common Values
| Value | Count | Frequency (%) |
| Larceny - From Vehicle | 144548 | |
| Larceny Theft - Other | 60647 | |
| Vandalism | 53633 | 9.6% |
| Motor Vehicle Theft | 45301 | 8.1% |
| Simple Assault | 29177 | 5.2% |
| Lost Property | 24509 | 4.4% |
| Fraud | 21473 | 3.8% |
| Burglary - Other | 17390 | 3.1% |
| Larceny Theft - Shoplifting | 17056 | 3.0% |
| Aggravated Assault | 16831 | 3.0% |
| Other values (43) | 129564 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 302812 | ||
| larceny | 245239 | |
| vehicle | 204640 | |
| from | 171637 | |
| theft | 156709 | |
| other | 85765 | 5.1% |
| vandalism | 53633 | 3.2% |
| assault | 46011 | 2.8% |
| motor | 45876 | 2.7% |
| burglary | 42970 | 2.6% |
| Other values (56) | 315367 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1110530 | 10.8% | |
| e | 1102810 | 10.8% |
| r | 808515 | 7.9% |
| a | 583868 | 5.7% |
| t | 525553 | 5.1% |
| i | 496281 | 4.8% |
| c | 490169 | 4.8% |
| l | 482828 | 4.7% |
| h | 464418 | 4.5% |
| o | 453370 | 4.4% |
| Other values (37) | 3739355 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 10257697 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1110530 | 10.8% | |
| e | 1102810 | 10.8% |
| r | 808515 | 7.9% |
| a | 583868 | 5.7% |
| t | 525553 | 5.1% |
| i | 496281 | 4.8% |
| c | 490169 | 4.8% |
| l | 482828 | 4.7% |
| h | 464418 | 4.5% |
| o | 453370 | 4.4% |
| Other values (37) | 3739355 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 10257697 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1110530 | 10.8% | |
| e | 1102810 | 10.8% |
| r | 808515 | 7.9% |
| a | 583868 | 5.7% |
| t | 525553 | 5.1% |
| i | 496281 | 4.8% |
| c | 490169 | 4.8% |
| l | 482828 | 4.7% |
| h | 464418 | 4.5% |
| o | 453370 | 4.4% |
| Other values (37) | 3739355 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 10257697 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1110530 | 10.8% | |
| e | 1102810 | 10.8% |
| r | 808515 | 7.9% |
| a | 583868 | 5.7% |
| t | 525553 | 5.1% |
| i | 496281 | 4.8% |
| c | 490169 | 4.8% |
| l | 482828 | 4.7% |
| h | 464418 | 4.5% |
| o | 453370 | 4.4% |
| Other values (37) | 3739355 |
description
Text
| Distinct | 556 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 MiB |
Length
| Max length | 80 |
|---|---|
| Median length | 59 |
| Mean length | 30.750061 |
| Min length | 4 |
Characters and Unicode
| Total characters | 17224001 |
|---|---|
| Distinct characters | 72 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 36 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Battery |
|---|---|
| 2nd row | Miscellaneous Investigation |
| 3rd row | Miscellaneous Investigation |
| 4th row | Fraudulent Game or Trick, Obtaining Money or Property |
| 5th row | Miscellaneous Investigation |
| Value | Count | Frequency (%) |
| theft | 246822 | 10.5% |
| vehicle | 216757 | 9.2% |
| from | 165590 | 7.0% |
| 950 | 161006 | 6.8% |
| locked | 124264 | 5.3% |
| property | 114810 | 4.9% |
| other | 78019 | 3.3% |
| stolen | 59176 | 2.5% |
| mischief | 51726 | 2.2% |
| malicious | 51726 | 2.2% |
| Other values (605) | 1089978 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1800648 | 10.5% | |
| e | 1669848 | 9.7% |
| o | 993693 | 5.8% |
| t | 990411 | 5.8% |
| r | 953957 | 5.5% |
| , | 848980 | 4.9% |
| i | 828843 | 4.8% |
| l | 698378 | 4.1% |
| h | 662204 | 3.8% |
| c | 661837 | 3.8% |
| Other values (62) | 7115202 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 17224001 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1800648 | 10.5% | |
| e | 1669848 | 9.7% |
| o | 993693 | 5.8% |
| t | 990411 | 5.8% |
| r | 953957 | 5.5% |
| , | 848980 | 4.9% |
| i | 828843 | 4.8% |
| l | 698378 | 4.1% |
| h | 662204 | 3.8% |
| c | 661837 | 3.8% |
| Other values (62) | 7115202 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 17224001 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1800648 | 10.5% | |
| e | 1669848 | 9.7% |
| o | 993693 | 5.8% |
| t | 990411 | 5.8% |
| r | 953957 | 5.5% |
| , | 848980 | 4.9% |
| i | 828843 | 4.8% |
| l | 698378 | 4.1% |
| h | 662204 | 3.8% |
| c | 661837 | 3.8% |
| Other values (62) | 7115202 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 17224001 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1800648 | 10.5% | |
| e | 1669848 | 9.7% |
| o | 993693 | 5.8% |
| t | 990411 | 5.8% |
| r | 953957 | 5.5% |
| , | 848980 | 4.9% |
| i | 828843 | 4.8% |
| l | 698378 | 4.1% |
| h | 662204 | 3.8% |
| c | 661837 | 3.8% |
| Other values (62) | 7115202 |
neighborhood
Categorical
HIGH CORRELATION
| Distinct | 41 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.5 MiB |
| Financial District/South Beach | |
|---|---|
| Mission | |
| Tenderloin | |
| South of Market | |
| Bayview Hunters Point | 31208 |
| Other values (36) |
Length
| Max length | 30 |
|---|---|
| Median length | 18 |
| Mean length | 14.849129 |
| Min length | 6 |
Characters and Unicode
| Total characters | 8317428 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mission |
|---|---|
| 2nd row | Tenderloin |
| 3rd row | Tenderloin |
| 4th row | Outer Richmond |
| 5th row | Financial District/South Beach |
Common Values
| Value | Count | Frequency (%) |
| Financial District/South Beach | 74375 | 13.3% |
| Mission | 56880 | 10.2% |
| Tenderloin | 44291 | 7.9% |
| South of Market | 37820 | 6.8% |
| Bayview Hunters Point | 31208 | 5.6% |
| North Beach | 21164 | 3.8% |
| Western Addition | 17443 | 3.1% |
| Marina | 17044 | 3.0% |
| Hayes Valley | 16756 | 3.0% |
| Sunset/Parkside | 15987 | 2.9% |
| Other values (31) | 227161 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| beach | 95539 | 8.6% |
| financial | 74375 | 6.7% |
| district/south | 74375 | 6.7% |
| mission | 72859 | 6.6% |
| market | 53387 | 4.8% |
| of | 49242 | 4.4% |
| tenderloin | 44291 | 4.0% |
| hill | 40366 | 3.6% |
| south | 37820 | 3.4% |
| bayview | 31208 | 2.8% |
| Other values (46) | 537337 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 828313 | 10.0% |
| e | 640225 | 7.7% |
| n | 622019 | 7.5% |
| t | 588128 | 7.1% |
| a | 584695 | 7.0% |
| 550670 | 6.6% | |
| o | 503015 | 6.0% |
| s | 466977 | 5.6% |
| r | 429666 | 5.2% |
| c | 314779 | 3.8% |
| Other values (36) | 2788941 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8317428 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 828313 | 10.0% |
| e | 640225 | 7.7% |
| n | 622019 | 7.5% |
| t | 588128 | 7.1% |
| a | 584695 | 7.0% |
| 550670 | 6.6% | |
| o | 503015 | 6.0% |
| s | 466977 | 5.6% |
| r | 429666 | 5.2% |
| c | 314779 | 3.8% |
| Other values (36) | 2788941 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8317428 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 828313 | 10.0% |
| e | 640225 | 7.7% |
| n | 622019 | 7.5% |
| t | 588128 | 7.1% |
| a | 584695 | 7.0% |
| 550670 | 6.6% | |
| o | 503015 | 6.0% |
| s | 466977 | 5.6% |
| r | 429666 | 5.2% |
| c | 314779 | 3.8% |
| Other values (36) | 2788941 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8317428 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 828313 | 10.0% |
| e | 640225 | 7.7% |
| n | 622019 | 7.5% |
| t | 588128 | 7.1% |
| a | 584695 | 7.0% |
| 550670 | 6.6% | |
| o | 503015 | 6.0% |
| s | 466977 | 5.6% |
| r | 429666 | 5.2% |
| c | 314779 | 3.8% |
| Other values (36) | 2788941 |
latitude
Real number (ℝ)
HIGH CORRELATION
| Distinct | 11405 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.770708 |
| Minimum | 37.707988 |
|---|---|
| Maximum | 37.829991 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 37.707988 |
|---|---|
| 5-th percentile | 37.721577 |
| Q1 | 37.757121 |
| median | 37.77749 |
| Q3 | 37.788269 |
| 95-th percentile | 37.803823 |
| Maximum | 37.829991 |
| Range | 0.1220025 |
| Interquartile range (IQR) | 0.031148193 |
Descriptive statistics
| Standard deviation | 0.024325427 |
|---|---|
| Coefficient of variation (CV) | 0.00064402888 |
| Kurtosis | -0.24542151 |
| Mean | 37.770708 |
| Median Absolute Deviation (MAD) | 0.012579433 |
| Skewness | -0.73442557 |
| Sum | 21156469 |
| Variance | 0.00059172638 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 37.7892407 | 29316 | 5.2% |
| 37.76126807 | 3684 | 0.7% |
| 37.78456014 | 3300 | 0.6% |
| 37.72694991 | 2770 | 0.5% |
| 37.78640961 | 2261 | 0.4% |
| 37.80549665 | 1924 | 0.3% |
| 37.78404444 | 1829 | 0.3% |
| 37.76505134 | 1795 | 0.3% |
| 37.78574399 | 1694 | 0.3% |
| 37.78445273 | 1616 | 0.3% |
| Other values (11395) | 509940 |
| Value | Count | Frequency (%) |
| 37.70798826 | 10 | < 0.1% |
| 37.70801926 | 3 | < 0.1% |
| 37.70802018 | 66 | |
| 37.7080307 | 1 | < 0.1% |
| 37.70805761 | 24 | < 0.1% |
| 37.70816803 | 1 | < 0.1% |
| 37.7082148 | 6 | < 0.1% |
| 37.70825596 | 51 | |
| 37.70830771 | 1 | < 0.1% |
| 37.70831127 | 79 |
| Value | Count | Frequency (%) |
| 37.82999075 | 92 | |
| 37.82999039 | 8 | < 0.1% |
| 37.82979202 | 1 | < 0.1% |
| 37.82979158 | 29 | < 0.1% |
| 37.8296814 | 1 | < 0.1% |
| 37.8296623 | 43 | |
| 37.82961662 | 33 | < 0.1% |
| 37.82961655 | 1 | < 0.1% |
| 37.82954858 | 107 | |
| 37.82954788 | 7 | < 0.1% |
longitude
Real number (ℝ)
HIGH CORRELATION
| Distinct | 11051 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -122.42379 |
| Minimum | -122.51142 |
|---|---|
| Maximum | -122.36374 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 560129 |
| Negative (%) | 100.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | -122.51142 |
|---|---|
| 5-th percentile | -122.48045 |
| Q1 | -122.43471 |
| median | -122.41753 |
| Q3 | -122.4058 |
| 95-th percentile | -122.39142 |
| Maximum | -122.36374 |
| Range | 0.14768219 |
| Interquartile range (IQR) | 0.028915118 |
Descriptive statistics
| Standard deviation | 0.026550604 |
|---|---|
| Coefficient of variation (CV) | -0.00021687455 |
| Kurtosis | 1.1224504 |
| Mean | -122.42379 |
| Median Absolute Deviation (MAD) | 0.013886066 |
| Skewness | -1.1627429 |
| Sum | -68573113 |
| Variance | 0.00070493456 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -122.4007224 | 29316 | 5.2% |
| -122.4167966 | 3684 | 0.7% |
| -122.407337 | 3300 | 0.6% |
| -122.4760395 | 2770 | 0.5% |
| -122.4080362 | 2261 | 0.4% |
| -122.4220068 | 1924 | 0.3% |
| -122.4037118 | 1829 | 0.3% |
| -122.419669 | 1795 | 0.3% |
| -122.405831 | 1694 | 0.3% |
| -122.4084932 | 1616 | 0.3% |
| Other values (11041) | 509940 |
| Value | Count | Frequency (%) |
| -122.5114212 | 7 | < 0.1% |
| -122.5112949 | 1442 | |
| -122.5112915 | 30 | < 0.1% |
| -122.5112839 | 2 | < 0.1% |
| -122.511055 | 5 | < 0.1% |
| -122.5109253 | 10 | < 0.1% |
| -122.5103413 | 20 | < 0.1% |
| -122.51017 | 5 | < 0.1% |
| -122.5101688 | 73 | < 0.1% |
| -122.5100403 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| -122.363739 | 6 | < 0.1% |
| -122.3637428 | 119 | |
| -122.3662872 | 1 | < 0.1% |
| -122.3679199 | 1 | < 0.1% |
| -122.3680954 | 2 | < 0.1% |
| -122.3682327 | 1 | < 0.1% |
| -122.36843 | 57 | |
| -122.3684311 | 2 | < 0.1% |
| -122.3690338 | 3 | < 0.1% |
| -122.3690371 | 40 | < 0.1% |
precipitation
Real number (ℝ)
ZEROS
| Distinct | 108 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.055742445 |
| Minimum | 0 |
|---|---|
| Maximum | 5.46 |
| Zeros | 461640 |
| Zeros (%) | 82.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.34 |
| Maximum | 5.46 |
| Range | 5.46 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.23694259 |
|---|---|
| Coefficient of variation (CV) | 4.2506673 |
| Kurtosis | 164.08547 |
| Mean | 0.055742445 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.154109 |
| Sum | 31222.96 |
| Variance | 0.056141791 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 461640 | |
| 0.01 | 11164 | 2.0% |
| 0.02 | 9030 | 1.6% |
| 0.04 | 4418 | 0.8% |
| 0.07 | 3568 | 0.6% |
| 0.03 | 3294 | 0.6% |
| 0.06 | 2585 | 0.5% |
| 0.21 | 2523 | 0.5% |
| 0.08 | 2302 | 0.4% |
| 0.3 | 1846 | 0.3% |
| Other values (98) | 57759 | 10.3% |
| Value | Count | Frequency (%) |
| 0 | 461640 | |
| 0.01 | 11164 | 2.0% |
| 0.02 | 9030 | 1.6% |
| 0.03 | 3294 | 0.6% |
| 0.04 | 4418 | 0.8% |
| 0.05 | 1018 | 0.2% |
| 0.06 | 2585 | 0.5% |
| 0.07 | 3568 | 0.6% |
| 0.08 | 2302 | 0.4% |
| 0.09 | 1499 | 0.3% |
| Value | Count | Frequency (%) |
| 5.46 | 230 | |
| 4.02 | 165 | |
| 3.15 | 251 | |
| 2.57 | 213 | |
| 2.49 | 226 | |
| 2.22 | 281 | |
| 1.67 | 177 | |
| 1.6 | 279 | |
| 1.5 | 192 | |
| 1.4 | 181 |
min_temperature
Real number (ℝ)
HIGH CORRELATION
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.698209 |
| Minimum | 39 |
|---|---|
| Maximum | 72 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 39 |
|---|---|
| 5-th percentile | 44 |
| Q1 | 49 |
| median | 52 |
| Q3 | 55 |
| 95-th percentile | 59 |
| Maximum | 72 |
| Range | 33 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.4715548 |
|---|---|
| Coefficient of variation (CV) | 0.086493418 |
| Kurtosis | 0.027618486 |
| Mean | 51.698209 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.017587858 |
| Sum | 28957666 |
| Variance | 19.994802 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 52 | 51187 | 9.1% |
| 54 | 48477 | 8.7% |
| 53 | 45852 | 8.2% |
| 51 | 44826 | 8.0% |
| 55 | 43377 | 7.7% |
| 49 | 41378 | 7.4% |
| 50 | 40379 | 7.2% |
| 56 | 34908 | 6.2% |
| 48 | 32350 | 5.8% |
| 57 | 27954 | 5.0% |
| Other values (21) | 149441 |
| Value | Count | Frequency (%) |
| 39 | 886 | 0.2% |
| 40 | 1555 | 0.3% |
| 41 | 2464 | 0.4% |
| 42 | 5025 | 0.9% |
| 43 | 8979 | 1.6% |
| 44 | 15793 | |
| 45 | 19413 | |
| 46 | 21090 | |
| 47 | 26096 | |
| 48 | 32350 |
| Value | Count | Frequency (%) |
| 72 | 236 | < 0.1% |
| 71 | 178 | < 0.1% |
| 69 | 170 | < 0.1% |
| 68 | 243 | < 0.1% |
| 65 | 477 | 0.1% |
| 64 | 1418 | 0.3% |
| 63 | 633 | 0.1% |
| 62 | 3243 | |
| 61 | 3824 | |
| 60 | 7852 |
max_temperature
Real number (ℝ)
HIGH CORRELATION
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 64.009794 |
| Minimum | 46 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 46 |
|---|---|
| 5-th percentile | 54 |
| Q1 | 59 |
| median | 63 |
| Q3 | 68 |
| 95-th percentile | 77 |
| Maximum | 100 |
| Range | 54 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 7.1465252 |
|---|---|
| Coefficient of variation (CV) | 0.11164737 |
| Kurtosis | 2.048087 |
| Mean | 64.009794 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 1.0303219 |
| Sum | 35853742 |
| Variance | 51.072823 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 63 | 36108 | 6.4% |
| 61 | 34655 | 6.2% |
| 62 | 34600 | 6.2% |
| 60 | 33739 | 6.0% |
| 64 | 33541 | 6.0% |
| 66 | 32963 | 5.9% |
| 65 | 32494 | 5.8% |
| 59 | 32449 | 5.8% |
| 67 | 28280 | 5.0% |
| 58 | 27314 | 4.9% |
| Other values (42) | 233986 |
| Value | Count | Frequency (%) |
| 46 | 206 | < 0.1% |
| 48 | 605 | 0.1% |
| 49 | 939 | 0.2% |
| 50 | 2558 | 0.5% |
| 51 | 1546 | 0.3% |
| 52 | 5007 | 0.9% |
| 53 | 9126 | |
| 54 | 12151 | |
| 55 | 16641 | |
| 56 | 19785 |
| Value | Count | Frequency (%) |
| 100 | 178 | < 0.1% |
| 98 | 235 | < 0.1% |
| 97 | 236 | < 0.1% |
| 95 | 193 | < 0.1% |
| 94 | 733 | |
| 93 | 467 | |
| 92 | 631 | |
| 91 | 652 | |
| 90 | 744 | |
| 89 | 426 |
deplaned_passenger
Real number (ℝ)
HIGH CORRELATION
| Distinct | 76 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1815323.4 |
| Minimum | 70582 |
|---|---|
| Maximum | 2905562 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 70582 |
|---|---|
| 5-th percentile | 377145 |
| Q1 | 1371431 |
| median | 2032485 |
| Q3 | 2278985 |
| 95-th percentile | 2798782 |
| Maximum | 2905562 |
| Range | 2834980 |
| Interquartile range (IQR) | 907554 |
Descriptive statistics
| Standard deviation | 715085.85 |
|---|---|
| Coefficient of variation (CV) | 0.3939165 |
| Kurtosis | -0.23766227 |
| Mean | 1815323.4 |
| Median Absolute Deviation (MAD) | 360087 |
| Skewness | -0.81448697 |
| Sum | 1.0168153 × 1012 |
| Variance | 5.1134777 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2112785 | 16685 | 3.0% |
| 2392572 | 8926 | 1.6% |
| 2905562 | 8880 | 1.6% |
| 2798782 | 8823 | 1.6% |
| 2889791 | 8799 | 1.6% |
| 2401192 | 8590 | 1.5% |
| 2172552 | 8561 | 1.5% |
| 2850432 | 8440 | 1.5% |
| 2533342 | 8417 | 1.5% |
| 2247754 | 8378 | 1.5% |
| Other values (66) | 465630 |
| Value | Count | Frequency (%) |
| 70582 | 4928 | |
| 141790 | 5754 | |
| 270718 | 5639 | |
| 367568 | 5689 | |
| 377145 | 6203 | |
| 400788 | 6503 | |
| 418398 | 6053 | |
| 436216 | 6381 | |
| 442442 | 5573 | |
| 522277 | 6171 |
| Value | Count | Frequency (%) |
| 2905562 | 8880 | |
| 2889791 | 8799 | |
| 2850432 | 8440 | |
| 2798782 | 8823 | |
| 2665667 | 7704 | |
| 2658235 | 7908 | |
| 2533342 | 8417 | |
| 2510276 | 8148 | |
| 2497897 | 7559 | |
| 2425591 | 8311 |
enplaned_passenger
Real number (ℝ)
HIGH CORRELATION
| Distinct | 76 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1804831.8 |
| Minimum | 68235 |
|---|---|
| Maximum | 2844325 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 68235 |
|---|---|
| 5-th percentile | 369120 |
| Q1 | 1360243 |
| median | 2006413 |
| Q3 | 2317631 |
| 95-th percentile | 2763785 |
| Maximum | 2844325 |
| Range | 2776090 |
| Interquartile range (IQR) | 957388 |
Descriptive statistics
| Standard deviation | 707785.71 |
|---|---|
| Coefficient of variation (CV) | 0.3921616 |
| Kurtosis | -0.26454461 |
| Mean | 1804831.8 |
| Median Absolute Deviation (MAD) | 393148 |
| Skewness | -0.80844854 |
| Sum | 1.0109386 × 1012 |
| Variance | 5.0096061 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2019052 | 16685 | 3.0% |
| 2425539 | 8926 | 1.6% |
| 2779507 | 8880 | 1.6% |
| 2740357 | 8823 | 1.6% |
| 2844325 | 8799 | 1.6% |
| 2317631 | 8590 | 1.5% |
| 2016637 | 8561 | 1.5% |
| 2754032 | 8440 | 1.5% |
| 2419322 | 8417 | 1.5% |
| 2217062 | 8378 | 1.5% |
| Other values (66) | 465630 |
| Value | Count | Frequency (%) |
| 68235 | 4928 | |
| 144780 | 5754 | |
| 284401 | 5639 | |
| 368635 | 5689 | |
| 369120 | 6503 | |
| 388129 | 6203 | |
| 434000 | 6053 | |
| 463550 | 5573 | |
| 482446 | 6381 | |
| 529962 | 6171 |
| Value | Count | Frequency (%) |
| 2844325 | 8799 | |
| 2793918 | 7704 | |
| 2779507 | 8880 | |
| 2763785 | 7908 | |
| 2754032 | 8440 | |
| 2740357 | 8823 | |
| 2513125 | 8148 | |
| 2505020 | 7559 | |
| 2430076 | 8311 | |
| 2425539 | 8926 |
| category | deplaned_passenger | enplaned_passenger | incident_day | incident_no | incident_year | latitude | longitude | max_temperature | min_temperature | neighborhood | precipitation | subcategory | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| category | 1.000 | -0.005 | -0.005 | 0.027 | 0.017 | 0.008 | -0.043 | 0.010 | -0.001 | -0.002 | 0.088 | -0.002 | 0.924 |
| deplaned_passenger | -0.005 | 1.000 | 0.987 | 0.012 | -0.340 | -0.358 | 0.039 | 0.039 | 0.155 | 0.247 | 0.036 | -0.056 | 0.055 |
| enplaned_passenger | -0.005 | 0.987 | 1.000 | 0.011 | -0.317 | -0.341 | 0.038 | 0.038 | 0.150 | 0.236 | 0.037 | -0.048 | 0.057 |
| incident_day | 0.027 | 0.012 | 0.011 | 1.000 | 0.001 | 0.004 | -0.011 | -0.005 | -0.006 | 0.012 | 0.018 | 0.014 | 0.033 |
| incident_no | 0.017 | -0.340 | -0.317 | 0.001 | 1.000 | 0.983 | -0.011 | -0.026 | -0.029 | -0.073 | 0.033 | 0.017 | 0.112 |
| incident_year | 0.008 | -0.358 | -0.341 | 0.004 | 0.983 | 1.000 | -0.032 | -0.032 | -0.050 | -0.103 | 0.048 | 0.023 | 0.078 |
| latitude | -0.043 | 0.039 | 0.038 | -0.011 | -0.011 | -0.032 | 1.000 | 0.209 | 0.005 | 0.014 | 0.769 | -0.005 | 0.121 |
| longitude | 0.010 | 0.039 | 0.038 | -0.005 | -0.026 | -0.032 | 0.209 | 1.000 | 0.002 | 0.002 | 0.679 | -0.002 | 0.104 |
| max_temperature | -0.001 | 0.155 | 0.150 | -0.006 | -0.029 | -0.050 | 0.005 | 0.002 | 1.000 | 0.707 | 0.007 | -0.406 | 0.012 |
| min_temperature | -0.002 | 0.247 | 0.236 | 0.012 | -0.073 | -0.103 | 0.014 | 0.002 | 0.707 | 1.000 | 0.010 | -0.210 | 0.015 |
| neighborhood | 0.088 | 0.036 | 0.037 | 0.018 | 0.033 | 0.048 | 0.769 | 0.679 | 0.007 | 0.010 | 1.000 | -0.000 | 0.089 |
| precipitation | -0.002 | -0.056 | -0.048 | 0.014 | 0.017 | 0.023 | -0.005 | -0.002 | -0.406 | -0.210 | -0.000 | 1.000 | 0.008 |
| subcategory | 0.924 | 0.055 | 0.057 | 0.033 | 0.112 | 0.078 | 0.121 | 0.104 | 0.012 | 0.015 | 0.089 | 0.008 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| incident_date | incident_time | incident_year | incident_day | incident_no | category | subcategory | description | neighborhood | latitude | longitude | precipitation | min_temperature | max_temperature | deplaned_passenger | enplaned_passenger | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 406 | 2018-01-01 | 00:55 | 2018 | Monday | 180000172 | Assault | Simple Assault | Battery | Mission | 37.768473 | -122.405828 | 0.0 | 48.0 | 61.0 | 2172552.0 | 2016637.0 |
| 48 | 2018-01-01 | 00:00 | 2018 | Monday | 200421296 | Miscellaneous Investigation | Miscellaneous Investigation | Miscellaneous Investigation | Tenderloin | 37.778719 | -122.414741 | 0.0 | 48.0 | 61.0 | 2172552.0 | 2016637.0 |
| 453 | 2018-01-01 | 00:00 | 2018 | Monday | 200421296 | Miscellaneous Investigation | Miscellaneous Investigation | Miscellaneous Investigation | Tenderloin | 37.778719 | -122.414741 | 0.0 | 48.0 | 61.0 | 2172552.0 | 2016637.0 |
| 487 | 2018-01-01 | 00:01 | 2018 | Monday | 200378998 | Fraud | Fraud | Fraudulent Game or Trick, Obtaining Money or Property | Outer Richmond | 37.781924 | -122.487020 | 0.0 | 48.0 | 61.0 | 2172552.0 | 2016637.0 |
| 123 | 2018-01-01 | 07:00 | 2018 | Monday | 200309028 | Miscellaneous Investigation | Miscellaneous Investigation | Miscellaneous Investigation | Financial District/South Beach | 37.786379 | -122.395645 | 0.0 | 48.0 | 61.0 | 2172552.0 | 2016637.0 |
| 376 | 2018-01-01 | 07:00 | 2018 | Monday | 206034998 | Larceny Theft | Larceny Theft - Other | Theft, Other Property, >$950 | Bayview Hunters Point | 37.720930 | -122.397271 | 0.0 | 48.0 | 61.0 | 2172552.0 | 2016637.0 |
| 112 | 2018-01-01 | 07:00 | 2018 | Monday | 206034998 | Larceny Theft | Larceny Theft - Other | Theft, Other Property, >$950 | Bayview Hunters Point | 37.720930 | -122.397271 | 0.0 | 48.0 | 61.0 | 2172552.0 | 2016637.0 |
| 414 | 2018-01-01 | 00:01 | 2018 | Monday | 200147248 | Fraud | Fraud | False Personation | Mission Bay | 37.772831 | -122.391374 | 0.0 | 48.0 | 61.0 | 2172552.0 | 2016637.0 |
| 277 | 2018-01-01 | 05:20 | 2018 | Monday | 180000570 | Assault | Aggravated Assault | Assault, Aggravated, W/ Gun | Financial District/South Beach | 37.785542 | -122.396705 | 0.0 | 48.0 | 61.0 | 2172552.0 | 2016637.0 |
| 530 | 2018-01-01 | 00:00 | 2018 | Monday | 200118738 | Larceny Theft | Theft From Vehicle | License Plate, Stolen | Mission | 37.760427 | -122.410962 | 0.0 | 48.0 | 61.0 | 2172552.0 | 2016637.0 |
| incident_date | incident_time | incident_year | incident_day | incident_no | category | subcategory | description | neighborhood | latitude | longitude | precipitation | min_temperature | max_temperature | deplaned_passenger | enplaned_passenger | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 867846 | 2024-07-09 | 14:20 | 2024 | Tuesday | 240427890 | Larceny Theft | Larceny - From Vehicle | Theft, From Locked Vehicle, $200-$950 | Mission | 37.769917 | -122.421585 | 0.0 | 56.0 | 71.0 | 2112785.0 | 2019052.0 |
| 867938 | 2024-07-09 | 09:40 | 2024 | Tuesday | 240427135 | Vandalism | Vandalism | Malicious Mischief, Vandalism to Property | Portola | 37.720768 | -122.404015 | 0.0 | 56.0 | 71.0 | 2112785.0 | 2019052.0 |
| 867926 | 2024-07-09 | 19:30 | 2024 | Tuesday | 240428713 | Larceny Theft | Larceny - From Vehicle | Theft, From Locked Vehicle, >$950 | North Beach | 37.805618 | -122.413605 | 0.0 | 56.0 | 71.0 | 2112785.0 | 2019052.0 |
| 867915 | 2024-07-09 | 09:19 | 2024 | Tuesday | 240427787 | Disorderly Conduct | Intimidation | Terrorist Threats | Tenderloin | 37.785789 | -122.412971 | 0.0 | 56.0 | 71.0 | 2112785.0 | 2019052.0 |
| 867850 | 2024-07-09 | 09:25 | 2024 | Tuesday | 240427072 | Assault | Simple Assault | Battery | Nob Hill | 37.788433 | -122.418556 | 0.0 | 56.0 | 71.0 | 2112785.0 | 2019052.0 |
| 867944 | 2024-07-09 | 11:00 | 2024 | Tuesday | 240427652 | Burglary | Burglary - Hot Prowl | Burglary, Hot Prowl, Forcible Entry | Portola | 37.733047 | -122.409691 | 0.0 | 56.0 | 71.0 | 2112785.0 | 2019052.0 |
| 867909 | 2024-07-09 | 11:00 | 2024 | Tuesday | 240427260 | Assault | Simple Assault | Battery | Bayview Hunters Point | 37.729160 | -122.392418 | 0.0 | 56.0 | 71.0 | 2112785.0 | 2019052.0 |
| 867839 | 2024-07-09 | 11:50 | 2024 | Tuesday | 240427511 | Assault | Simple Assault | Battery | Mission | 37.749271 | -122.414337 | 0.0 | 56.0 | 71.0 | 2112785.0 | 2019052.0 |
| 867891 | 2024-07-09 | 11:30 | 2024 | Tuesday | 240427408 | Assault | Simple Assault | Battery | South of Market | 37.784477 | -122.404266 | 0.0 | 56.0 | 71.0 | 2112785.0 | 2019052.0 |
| 867901 | 2024-07-09 | 22:00 | 2024 | Tuesday | 240428729 | Vandalism | Vandalism | Malicious Mischief, Vandalism to Property | Tenderloin | 37.780952 | -122.411987 | 0.0 | 56.0 | 71.0 | 2112785.0 | 2019052.0 |
Most frequently occurring
| incident_date | incident_time | incident_year | incident_day | incident_no | category | subcategory | description | neighborhood | latitude | longitude | precipitation | min_temperature | max_temperature | deplaned_passenger | enplaned_passenger | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 498 | 2018-03-07 | 07:00 | 2018 | Wednesday | 190202001 | Larceny Theft | Larceny Theft - Other | Theft, Other Property, >$950 | Haight Ashbury | 37.772620 | -122.433922 | 0.02 | 53.0 | 69.0 | 2320899.0 | 2352210.0 | 55 |
| 484 | 2018-03-06 | 06:00 | 2018 | Tuesday | 190202001 | Larceny Theft | Larceny Theft - Other | Theft, Other Property, >$950 | Haight Ashbury | 37.772620 | -122.433922 | 0.00 | 47.0 | 66.0 | 2320899.0 | 2352210.0 | 14 |
| 486 | 2018-03-06 | 07:00 | 2018 | Tuesday | 190202001 | Larceny Theft | Larceny Theft - Other | Theft, Other Property, >$950 | Haight Ashbury | 37.772620 | -122.433922 | 0.00 | 47.0 | 66.0 | 2320899.0 | 2352210.0 | 10 |
| 523 | 2018-03-10 | 01:00 | 2018 | Saturday | 190202001 | Larceny Theft | Larceny Theft - Other | Theft, Other Property, >$950 | Haight Ashbury | 37.772620 | -122.433922 | 0.00 | 47.0 | 58.0 | 2320899.0 | 2352210.0 | 9 |
| 1822 | 2018-09-06 | 10:30 | 2018 | Thursday | 186212385 | Larceny Theft | Larceny - From Vehicle | Theft, From Locked Vehicle, >$950 | Golden Gate Park | 37.773304 | -122.468024 | 0.00 | 55.0 | 61.0 | 2340188.0 | 2302919.0 | 9 |
| 8186 | 2021-08-09 | 03:40 | 2021 | Monday | 210504882 | Motor Vehicle Theft | Motor Vehicle Theft | Vehicle, Stolen, Other Vehicle | Tenderloin | 37.781177 | -122.411700 | 0.00 | 56.0 | 67.0 | 1356733.0 | 1292158.0 | 9 |
| 499 | 2018-03-07 | 07:00 | 2018 | Wednesday | 190202001 | Larceny Theft | Larceny Theft - Other | Theft, Other Property, >$950 | Mission | 37.768178 | -122.410731 | 0.02 | 53.0 | 69.0 | 2320899.0 | 2352210.0 | 8 |
| 11190 | 2022-11-16 | 14:00 | 2022 | Wednesday | 226217431 | Larceny Theft | Larceny - From Vehicle | Theft, From Locked Vehicle, >$950 | Japantown | 37.785373 | -122.431366 | 0.00 | 47.0 | 69.0 | 1808759.0 | 1841032.0 | 8 |
| 770 | 2018-04-10 | 01:00 | 2018 | Tuesday | 190202001 | Larceny Theft | Larceny Theft - Other | Theft, Other Property, $50-$200 | Haight Ashbury | 37.772620 | -122.433922 | 0.00 | 52.0 | 63.0 | 2393156.0 | 2318680.0 | 7 |
| 1560 | 2018-08-02 | 17:00 | 2018 | Thursday | 186202897 | Larceny Theft | Larceny - From Vehicle | Theft, From Locked Vehicle, >$950 | North Beach | 37.805185 | -122.403436 | 0.00 | 52.0 | 63.0 | 2798782.0 | 2740357.0 | 7 |